package com.xxxt.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.xxxt.entity.ClassGrade;
import com.xxxt.entity.Student;

public interface ClassGradeMapper {
	/**
	 * 
	 * @param classGrade
	 */
	public boolean updateClassGrade(@Param("classGrades") ClassGrade classGrade);

	/**
	 * 
	 * @param ClassGradeId
	 * @return
	 */
	public ClassGrade queryOneClassGradeByClassGradeId(String ClassGradeId);

	List<ClassGrade> selectAllClassGradeByGradeId(String gradeId);

	boolean insertOneClassGrade(ClassGrade classGrade);

	List<ClassGrade> selcetAllClassGrade();

	List<ClassGrade> selcetAllPageClassGradeByGradeId(String gradeId);

	boolean deleteClassGrade(String classGradeId);

	boolean updateClassGradeForAdmin(@Param("classGradeId") String classGradeId,
			@Param("classGrade") String classGradeName, @Param("gradeId") String gradeId,
			@Param("id") String id);

	List<Student> selectStudentByTnoAndClassGrade(@Param("tno") String tno, @Param("classGradeId") String classGradeId);

	List<Student> selectStudentByTnoAndList(@Param("tno") String tno, @Param("list") List<ClassGrade> classGradeIds);

	ClassGrade selectOneClassGradeByClassGradeId(String classGradeId);

	ClassGrade selectClassGradeByClassGradeId(String classGradeId);

	ClassGrade selectClassGradeByName(@Param("classGrade") String classGrade,@Param("gradeId") String gradeId);

}
